JSON Mapping of Photos
Wendy Anthony
2022/04/15
1 Convert csv to json
2 load library
library("jsonlite")
library("dplyr")##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union3 Data
3.1 read csv
exif <- read.csv("./data/2022-04-14-MtDouglas-Exif.csv")
exif## SourceFile DateTimeOriginal GPSLongitude GPSLatitude ExposureTime
## 1 DSCN7961.JPG 2022:04:14 14:21:41 NA NA 0.0020000000
## 2 DSCN7962.JPG 2022:04:14 14:21:47 NA NA 0.0020000000
## 3 DSCN7963.JPG 2022:04:14 14:21:54 NA NA 0.0020000000
## 4 DSCN7965.JPG 2022:04:14 14:50:57 -123.3453 48.49260 0.0025000000
## 5 DSCN7966.JPG 2022:04:14 14:51:05 -123.3452 48.49255 0.0025000000
## 6 DSCN7967.JPG 2022:04:14 14:51:11 -123.3452 48.49252 0.0025000000
## 7 DSCN7968.JPG 2022:04:14 14:51:13 -123.3452 48.49252 0.0025000000
## 8 DSCN7969.JPG 2022:04:14 14:51:15 -123.3452 48.49256 0.0025000000
## 9 DSCN7970 copy.JPG 2022:04:14 14:51:16 -123.3452 48.49258 0.0025000000
## 10 DSCN7970.JPG 2022:04:14 14:51:16 -123.3452 48.49258 0.0025000000
## 11 DSCN7971.JPG 2022:04:14 14:52:28 -123.3454 48.49294 0.0200000000
## 12 DSCN7973.JPG 2022:04:14 14:52:30 -123.3454 48.49294 0.0200000000
## 13 DSCN7975.JPG 2022:04:14 14:52:41 -123.3453 48.49288 0.0080000000
## 14 DSCN7977.JPG 2022:04:14 14:53:54 -123.3454 48.49312 0.0125000000
## 15 DSCN7978.JPG 2022:04:14 14:54:26 -123.3455 48.49312 0.0020000000
## 16 DSCN7979.JPG 2022:04:14 14:54:29 -123.3454 48.49313 0.0100000000
## 17 DSCN7980.JPG 2022:04:14 14:54:42 -123.3455 48.49312 0.0080000000
## 18 DSCN7982.JPG 2022:04:14 14:54:58 -123.3456 48.49306 0.0166666667
## 19 DSCN7983.JPG 2022:04:14 14:55:04 -123.3456 48.49303 0.0333333333
## 20 DSCN7984.JPG 2022:04:14 14:55:09 -123.3457 48.49317 0.0333333333
## 21 DSCN7985.JPG 2022:04:14 14:55:12 -123.3457 48.49321 0.0250000000
## 22 DSCN7987.JPG 2022:04:14 14:56:31 -123.3454 48.49302 0.0062500000
## 23 DSCN7988.JPG 2022:04:14 14:56:33 -123.3456 48.49297 0.0062500000
## 24 DSCN7989.JPG 2022:04:14 14:56:36 -123.3456 48.49303 0.0050000000
## 25 DSCN7991.JPG 2022:04:14 14:56:47 -123.3456 48.49305 0.0040000000
## 26 DSCN7992.JPG 2022:04:14 14:57:21 -123.3456 48.49316 0.0250000000
## 27 DSCN7999.JPG 2022:04:14 14:58:25 -123.3457 48.49313 0.0166666667
## 28 DSCN8000.JPG 2022:04:14 14:58:27 -123.3457 48.49311 0.0200000000
## 29 DSCN8002.JPG 2022:04:14 14:58:35 -123.3456 48.49307 0.0200000000
## 30 DSCN8004.JPG 2022:04:14 14:58:53 -123.3456 48.49305 0.0200000000
## 31 DSCN8005.JPG 2022:04:14 14:59:07 -123.3456 48.49307 0.0166666667
## 32 DSCN8006.JPG 2022:04:14 14:59:16 -123.3456 48.49316 0.0166666667
## 33 DSCN8007.JPG 2022:04:14 14:59:17 -123.3456 48.49314 0.0166666667
## 34 DSCN8008.JPG 2022:04:14 15:00:58 -123.3457 48.49288 0.0020000000
## 35 DSCN8009.JPG 2022:04:14 15:01:04 -123.3457 48.49294 0.0015625000
## 36 DSCN8011.JPG 2022:04:14 15:01:37 -123.3456 48.49300 0.0025000000
## 37 DSCN8012.JPG 2022:04:14 15:01:40 -123.3456 48.49301 0.0025000000
## 38 DSCN8013.JPG 2022:04:14 15:01:56 -123.3457 48.49303 0.0050000000
## 39 DSCN8014.JPG 2022:04:14 15:02:51 -123.3458 48.49294 0.0010000000
## 40 DSCN8017.JPG 2022:04:14 15:03:24 -123.3458 48.49291 0.0008000000
## 41 DSCN8018.JPG 2022:04:14 15:03:25 -123.3458 48.49291 0.0012500000
## 42 DSCN8019.JPG 2022:04:14 15:03:26 -123.3458 48.49291 0.0012500000
## 43 DSCN8020.JPG 2022:04:14 15:03:42 -123.3458 48.49286 0.0015625000
## 44 DSCN8021.JPG 2022:04:14 15:04:05 -123.3458 48.49284 0.0012500000
## 45 DSCN8023.JPG 2022:04:14 15:04:31 -123.3458 48.49282 0.0025000000
## 46 DSCN8024.JPG 2022:04:14 15:04:46 -123.3458 48.49281 0.0012500000
## 47 DSCN8025.JPG 2022:04:14 15:04:47 -123.3458 48.49281 0.0015625000
## 48 DSCN8026.JPG 2022:04:14 15:06:58 -123.3460 48.49277 0.0025000000
## 49 DSCN8027.JPG 2022:04:14 15:07:27 -123.3457 48.49285 0.0031250000
## 50 DSCN8030.JPG 2022:04:14 15:07:58 -123.3457 48.49287 0.0008000000
## 51 DSCN8031.JPG 2022:04:14 15:08:37 -123.3457 48.49283 0.0012500000
## 52 DSCN8032.JPG 2022:04:14 15:08:42 -123.3457 48.49283 0.0012500000
## 53 DSCN8034.JPG 2022:04:14 15:09:19 -123.3457 48.49283 0.0012500000
## 54 DSCN8036.JPG 2022:04:14 15:09:21 -123.3457 48.49283 0.0025000000
## 55 DSCN8038.JPG 2022:04:14 15:09:25 -123.3457 48.49283 0.0025000000
## 56 DSCN8039.JPG 2022:04:14 15:10:19 -123.3456 48.49292 0.0062500000
## 57 DSCN8040.JPG 2022:04:14 15:10:21 -123.3456 48.49291 0.0062500000
## 58 DSCN8041.JPG 2022:04:14 15:10:25 -123.3456 48.49291 0.0012500000
## 59 DSCN8042.JPG 2022:04:14 15:10:26 -123.3456 48.49292 0.0012500000
## 60 DSCN8044.JPG 2022:04:14 15:10:35 -123.3456 48.49292 0.0012500000
## 61 DSCN8045.JPG 2022:04:14 15:10:37 -123.3456 48.49292 0.0008000000
## 62 DSCN8046.JPG 2022:04:14 15:10:39 -123.3456 48.49292 0.0008000000
## 63 DSCN8047.JPG 2022:04:14 15:10:44 -123.3456 48.49291 0.0025000000
## 64 DSCN8048.JPG 2022:04:14 15:14:35 -123.3456 48.49291 0.0031250000
## 65 DSCN8050.JPG 2022:04:14 15:14:40 -123.3458 48.49278 0.0031250000
## 66 DSCN8051.JPG 2022:04:14 15:14:44 -123.3459 48.49280 0.0025000000
## 67 DSCN8052.JPG 2022:04:14 15:40:05 -123.3458 48.49301 0.0166666667
## 68 DSCN8053.JPG 2022:04:14 15:40:15 -123.3461 48.49280 0.0050000000
## 69 DSCN8054.JPG 2022:04:14 15:45:12 NA NA 0.0020000000
## 70 DSCN8055.JPG 2022:04:14 15:45:15 -123.3458 48.49285 0.0010000000
## 71 DSCN8056.JPG 2022:04:14 15:45:17 -123.3458 48.49289 0.0012500000
## 72 DSCN8057.JPG 2022:04:14 15:45:20 -123.3458 48.49288 0.0008000000
## 73 DSCN8058.JPG 2022:04:14 15:46:11 -123.3462 48.49276 0.0008000000
## 74 DSCN8059.JPG 2022:04:14 15:46:14 -123.3462 48.49275 0.0015625000
## 75 DSCN8060.JPG 2022:04:14 15:47:56 -123.3464 48.49286 0.0040000000
## 76 DSCN8061.JPG 2022:04:14 15:48:07 -123.3464 48.49290 0.0008000000
## 77 DSCN8062.JPG 2022:04:14 15:48:15 -123.3464 48.49290 0.0006666667
## 78 DSCN8063.JPG 2022:04:14 15:48:28 -123.3464 48.49290 0.0025000000
## 79 DSCN8064.JPG 2022:04:14 15:49:12 -123.3465 48.49297 0.0008000000
## 80 DSCN8065.JPG 2022:04:14 15:53:39 -123.3466 48.49294 0.0012500000
## 81 DSCN8066.JPG 2022:04:14 15:53:43 -123.3468 48.49292 0.0015625000
## 82 DSCN8067 copy.JPG 2022:04:14 15:53:46 -123.3468 48.49293 0.0015625000
## 83 DSCN8067.JPG 2022:04:14 15:53:46 -123.3468 48.49293 0.0015625000
## 84 DSCN8068.JPG 2022:04:14 15:53:52 -123.3468 48.49293 0.0012500000
## 85 DSCN8069.JPG 2022:04:14 15:53:55 -123.3468 48.49295 0.0012500000
## 86 DSCN8070.JPG 2022:04:14 15:53:59 -123.3468 48.49296 0.0012500000
## 87 DSCN8071.JPG 2022:04:14 15:55:14 -123.3468 48.49300 0.0015625000
## 88 DSCN8072.JPG 2022:04:14 15:55:17 -123.3468 48.49300 0.0025000000
## 89 DSCN8073.JPG 2022:04:14 15:55:49 -123.3468 48.49300 0.0015625000
## 90 DSCN8074 copy.JPG 2022:04:14 15:56:06 -123.3468 48.49303 0.0031250000
## 91 DSCN8074.JPG 2022:04:14 15:56:06 -123.3468 48.49303 0.0031250000
## 92 DSCN8076 copy.JPG 2022:04:14 15:56:20 -123.3468 48.49302 0.0080000000
## 93 DSCN8076.JPG 2022:04:14 15:56:20 -123.3468 48.49302 0.0080000000
## 94 DSCN8079.JPG 2022:04:14 15:57:04 -123.3468 48.49302 0.0020000000
## 95 DSCN8080.JPG 2022:04:14 15:57:29 -123.3468 48.49302 0.0012500000
## 96 DSCN8082.JPG 2022:04:14 15:57:52 -123.3468 48.49303 0.0020000000
## 97 DSCN8084.JPG 2022:04:14 15:58:14 -123.3468 48.49303 0.0012500000
## 98 DSCN8085.JPG 2022:04:14 15:58:16 -123.3468 48.49303 0.0012500000
## 99 DSCN8088.JPG 2022:04:14 16:02:18 -123.3469 48.49297 0.0050000000
## 100 DSCN8089.JPG 2022:04:14 16:02:22 -123.3469 48.49296 0.0062500000
## 101 DSCN8091.JPG 2022:04:14 16:03:26 -123.3467 48.49304 0.0031250000
## 102 DSCN8092.JPG 2022:04:14 16:03:38 -123.3467 48.49304 0.0031250000
## 103 DSCN8094.JPG 2022:04:14 16:04:20 -123.3468 48.49301 0.0012500000
## 104 DSCN8095 copy.JPG 2022:04:14 16:04:25 -123.3468 48.49301 0.0012500000
## 105 DSCN8095.JPG 2022:04:14 16:04:25 -123.3468 48.49301 0.0012500000
## 106 DSCN8097.JPG 2022:04:14 16:06:02 -123.3465 48.49309 0.0012500000
## 107 DSCN8098.JPG 2022:04:14 16:06:03 -123.3465 48.49309 0.0012500000
## 108 DSCN8099.JPG 2022:04:14 16:06:07 -123.3466 48.49304 0.0012500000
## 109 DSCN8100.JPG 2022:04:14 16:06:12 -123.3466 48.49294 0.0012500000
## 110 DSCN8101.JPG 2022:04:14 16:06:16 -123.3466 48.49292 0.0025000000
## 111 DSCN8102.JPG 2022:04:14 16:11:02 -123.3465 48.49299 0.0012500000
## 112 DSCN8103.JPG 2022:04:14 16:11:14 -123.3463 48.49283 0.0008000000
## 113 DSCN8104.JPG 2022:04:14 16:11:30 -123.3463 48.49282 0.0010000000
## 114 DSCN8105.JPG 2022:04:14 16:11:46 -123.3463 48.49283 0.0012500000
## 115 DSCN8107.JPG 2022:04:14 16:15:18 -123.3463 48.49268 0.0008000000
## 116 DSCN8108.JPG 2022:04:14 16:19:37 -123.3464 48.49247 0.0025000000
## 117 DSCN8109.JPG 2022:04:14 16:19:40 -123.3464 48.49247 0.0025000000
## 118 DSCN8110.JPG 2022:04:14 16:26:36 -123.3449 48.49238 0.0125000000
## 119 DSCN8111.JPG 2022:04:14 16:26:40 -123.3450 48.49238 0.0100000000
## 120 DSCN8112.JPG 2022:04:14 16:26:46 -123.3450 48.49237 0.0010000000
## 121 DSCN8114.JPG 2022:04:14 16:26:49 -123.3450 48.49237 0.0012500000
## 122 DSCN8115.JPG 2022:04:14 16:32:13 -123.3448 48.49186 0.0010000000
## 123 DSCN8117.JPG 2022:04:14 16:32:40 -123.3448 48.49190 0.0025000000
## 124 DSCN8118.JPG 2022:04:14 16:34:46 -123.3449 48.49186 0.0020000000
## 125 DSCN8119.JPG 2022:04:14 16:34:50 -123.3450 48.49175 0.0010000000
## 126 DSCN8120.JPG 2022:04:14 16:34:56 -123.3450 48.49175 0.0015625000
## 127 DSCN8121.JPG 2022:04:14 16:35:05 -123.3449 48.49176 0.0015625000
## 128 DSCN8122.JPG 2022:04:14 16:35:10 -123.3449 48.49175 0.0010000000
## 129 DSCN8123.JPG 2022:04:14 16:35:12 -123.3449 48.49175 0.0010000000
## 130 DSCN8124.JPG 2022:04:14 16:35:13 -123.3449 48.49175 0.0010000000
## 131 DSCN8128.JPG 2022:04:14 16:38:11 -123.3450 48.49201 0.0025000000
## 132 DSCN8131.JPG 2022:04:14 16:38:21 -123.3450 48.49201 0.0031250000
## 133 DSCN8132.JPG 2022:04:14 16:38:24 -123.3450 48.49201 0.0031250000
## 134 DSCN8133.JPG 2022:04:14 16:38:26 -123.3450 48.49201 0.0031250000
## 135 DSCN8134.JPG 2022:04:14 16:38:28 -123.3450 48.49202 0.0031250000
## 136 DSCN8135.JPG 2022:04:14 16:38:29 -123.3450 48.49202 0.0031250000
## 137 DSCN8136.JPG 2022:04:14 16:38:46 -123.3450 48.49205 0.0031250000
## 138 DSCN8137.JPG 2022:04:14 16:39:08 -123.3450 48.49207 0.0025000000
## 139 DSCN8138.JPG 2022:04:14 16:39:12 -123.3450 48.49206 0.0031250000
## 140 DSCN8141.JPG 2022:04:14 16:39:56 -123.3450 48.49208 0.0010000000
## 141 DSCN8142.JPG 2022:04:14 16:39:57 -123.3450 48.49208 0.0010000000
## 142 DSCN8143.JPG 2022:04:14 16:40:07 -123.3450 48.49208 0.0010000000
## 143 DSCN8146.JPG 2022:04:14 16:40:13 -123.3450 48.49207 0.0010000000
## 144 DSCN8147.JPG 2022:04:14 16:41:03 -123.3449 48.49232 0.0010000000
## 145 DSCN8148.JPG 2022:04:14 16:41:22 -123.3448 48.49233 0.0010000000
## 146 DSCN8149.JPG 2022:04:14 16:50:02 -123.3450 48.49245 0.0400000000
## 147 DSCN8150.JPG 2022:04:14 16:50:29 -123.3428 48.49626 0.0400000000
## 148 DSCN8151.JPG 2022:04:14 16:50:35 -123.3428 48.49621 0.0500000000
## 149 DSCN8152.JPG 2022:04:14 16:50:51 -123.3427 48.49616 0.0333333333
## 150 DSCN8153.JPG 2022:04:14 16:51:42 -123.3425 48.49620 0.0333333333
## 151 DSCN8154.JPG 2022:04:14 16:51:48 -123.3425 48.49619 0.0333333333
## 152 DSCN8156.JPG 2022:04:14 16:52:24 -123.3422 48.49614 0.0062500000
## 153 DSCN8157.JPG 2022:04:14 16:52:47 -123.3423 48.49607 0.0333333333
## 154 DSCN8158.JPG 2022:04:14 16:52:51 -123.3423 48.49608 0.0333333333
## 155 DSCN8161.JPG 2022:04:14 16:53:01 -123.3424 48.49608 0.0333333333
## 156 DSCN8162.JPG 2022:04:14 16:53:06 -123.3424 48.49609 0.0333333333
## 157 DSCN8163.JPG 2022:04:14 16:53:19 -123.3423 48.49606 0.0250000000
## 158 DSCN8164.JPG 2022:04:14 16:53:23 -123.3423 48.49609 0.0200000000
## 159 DSCN8165.JPG 2022:04:14 16:53:28 -123.3423 48.49613 0.0333333333
## 160 DSCN8167.JPG 2022:04:14 16:53:59 -123.3422 48.49608 0.0062500000
## 161 DSCN8168.JPG 2022:04:14 16:54:04 -123.3422 48.49609 0.0008000000
## 162 DSCN8169.JPG 2022:04:14 16:54:07 -123.3422 48.49610 0.0050000000
## 163 DSCN8170.JPG 2022:04:14 16:55:51 -123.3420 48.49616 0.0062500000
## 164 DSCN8171.JPG 2022:04:14 16:56:04 -123.3422 48.49643 0.0166666667
## 165 DSCN8172.JPG 2022:04:14 16:56:10 -123.3422 48.49638 0.0333333333
## 166 DSCN8174.JPG 2022:04:14 16:56:16 -123.3422 48.49635 0.0050000000
## 167 DSCN8175.JPG 2022:04:14 16:56:32 -123.3421 48.49627 0.0100000000
## 168 DSCN8176.JPG 2022:04:14 16:57:06 -123.3425 48.49628 0.0080000000
## 169 DSCN8177.JPG 2022:04:14 16:57:09 -123.3425 48.49629 0.0125000000
## 170 DSCN8180.JPG 2022:04:14 16:58:00 -123.3425 48.49620 0.0166666667
## 171 DSCN8182.JPG 2022:04:14 16:58:07 -123.3425 48.49621 0.0100000000
## 172 DSCN8183.JPG 2022:04:14 16:58:13 -123.3425 48.49618 0.0250000000
## 173 DSCN8184.JPG 2022:04:14 17:01:16 NA NA 0.0333333333
## 174 DSCN8185.JPG 2022:04:14 17:01:40 -123.3423 48.49628 0.0080000000
## 175 DSCN8188.JPG 2022:04:14 17:02:02 -123.3424 48.49634 0.0100000000
## 176 DSCN8189.JPG 2022:04:14 17:02:14 -123.3423 48.49626 0.0333333333
## 177 DSCN8191.JPG 2022:04:14 17:02:19 -123.3423 48.49624 0.0333333333
## 178 DSCN8192.JPG 2022:04:14 17:02:38 -123.3423 48.49624 0.0250000000
## 179 DSCN8196.JPG 2022:04:14 17:02:51 -123.3423 48.49630 0.0333333333
## 180 DSCN8198.JPG 2022:04:14 17:03:05 -123.3423 48.49621 0.0333333333
## 181 DSCN8199.JPG 2022:04:14 17:04:38 -123.3428 48.49634 0.0333333333
## 182 DSCN8200.JPG 2022:04:14 17:05:06 -123.3428 48.49627 0.0040000000
## 183 DSCN8201.JPG 2022:04:14 17:05:10 -123.3428 48.49627 0.0333333333
## 184 DSCN8202.JPG 2022:04:14 17:05:12 -123.3428 48.49627 0.0166666667
## 185 DSCN8203.JPG 2022:04:14 17:05:14 -123.3428 48.49628 0.0125000000
## 186 DSCN8204.JPG 2022:04:14 17:05:16 -123.3428 48.49628 0.0040000000
## 187 DSCN8205.JPG 2022:04:14 17:16:22 -123.3428 48.49645 0.0333333333
## 188 DSCN8206.JPG 2022:04:14 17:16:27 -123.3428 48.49642 0.0333333333
## 189 DSCN8207.JPG 2022:04:14 17:16:30 -123.3427 48.49637 0.0025000000
## 190 DSCN8208.JPG 2022:04:14 17:16:35 -123.3427 48.49638 0.0333333333
## 191 DSCN8209.JPG 2022:04:14 17:26:20 NA NA 0.0200000000
## 192 DSCN8211.JPG 2022:04:14 17:26:30 -123.3382 48.49101 0.0200000000
## 193 DSCN8212.JPG 2022:04:14 17:26:35 -123.3382 48.49101 0.0200000000
## 194 DSCN8213.JPG 2022:04:14 17:26:36 -123.3382 48.49101 0.0200000000
## 195 DSCN8215.JPG 2022:04:14 17:26:48 -123.3383 48.49098 0.0333333333
## 196 DSCN8216.JPG 2022:04:14 17:26:50 -123.3383 48.49096 0.0333333333
## 197 DSCN8217.JPG 2022:04:14 17:26:56 -123.3383 48.49094 0.0333333333
## 198 DSCN8218.JPG 2022:04:14 17:27:15 -123.3382 48.49085 0.0333333333
## 199 DSCN8219.JPG 2022:04:14 17:27:29 -123.3382 48.49092 0.0200000000
## 200 DSCN8220.JPG 2022:04:14 17:27:37 -123.3382 48.49094 0.0166666667
## 201 DSCN8221.JPG 2022:04:14 17:28:25 -123.3380 48.49093 0.0400000000
## 202 DSCN8222.JPG 2022:04:14 17:28:32 -123.3380 48.49092 0.0333333333
## 203 DSCN8223.JPG 2022:04:14 17:28:40 -123.3380 48.49095 0.0100000000
## 204 DSCN8225.JPG 2022:04:14 17:28:49 -123.3380 48.49095 0.0200000000
## 205 DSCN8227.JPG 2022:04:14 17:29:10 -123.3381 48.49095 0.0333333333
## 206 DSCN8229.JPG 2022:04:14 17:29:29 -123.3382 48.49106 0.0200000000
## 207 DSCN8230.JPG 2022:04:14 17:29:48 -123.3383 48.49115 0.0100000000
## 208 DSCN8231.JPG 2022:04:14 17:29:52 -123.3384 48.49121 0.0166666667
## 209 DSCN8232.JPG 2022:04:14 17:30:10 -123.3384 48.49123 0.0333333333
## 210 DSCN8234.JPG 2022:04:14 17:30:38 -123.3385 48.49136 0.0333333333
## 211 DSCN8236.JPG 2022:04:14 17:31:00 -123.3387 48.49143 0.0333333333
## 212 DSCN8237.JPG 2022:04:14 17:31:05 -123.3387 48.49142 0.0050000000
## 213 DSCN8238.JPG 2022:04:14 17:31:27 -123.3387 48.49137 0.0333333333
## 214 DSCN8239.JPG 2022:04:14 17:32:05 -123.3389 48.49135 0.0080000000
## 215 DSCN8242.JPG 2022:04:14 17:32:27 -123.3390 48.49139 0.0333333333
## 216 DSCN8244.JPG 2022:04:14 17:32:35 -123.3389 48.49141 0.0333333333
## 217 DSCN8245.JPG 2022:04:14 17:32:42 -123.3389 48.49143 0.0500000000
## 218 DSCN8246.JPG 2022:04:14 17:32:43 -123.3389 48.49142 0.0500000000
## 219 DSCN8247.JPG 2022:04:14 17:32:48 -123.3389 48.49138 0.0333333333
## 220 DSCN8248.JPG 2022:04:14 17:33:03 -123.3390 48.49137 0.0333333333
## 221 DSCN8251.JPG 2022:04:14 17:33:10 -123.3390 48.49135 0.0333333333
## 222 DSCN8255.JPG 2022:04:14 17:33:17 -123.3390 48.49129 0.0333333333
## 223 DSCN8258.JPG 2022:04:14 17:33:29 -123.3390 48.49126 0.0333333333
## 224 DSCN8259.JPG 2022:04:14 17:33:31 -123.3390 48.49128 0.0333333333
## 225 DSCN8275.JPG 2022:04:14 17:34:19 -123.3390 48.49138 0.0333333333
## 226 DSCN8276.JPG 2022:04:14 17:34:25 -123.3390 48.49140 0.0250000000
## 227 DSCN8277.JPG 2022:04:14 17:34:26 -123.3390 48.49140 0.0250000000
## 228 DSCN8280.JPG 2022:04:14 17:34:49 -123.3390 48.49141 0.0200000000
## 229 DSCN8281.JPG 2022:04:14 17:34:55 -123.3390 48.49142 0.0166666667
## 230 DSCN8283.JPG 2022:04:14 17:35:15 -123.3390 48.49144 0.0333333333
## 231 DSCN8285.JPG 2022:04:14 17:36:10 -123.3394 48.49144 0.0400000000
## 232 DSCN8287.JPG 2022:04:14 17:36:29 -123.3394 48.49140 0.0333333333
## 233 DSCN8288.JPG 2022:04:14 17:36:36 -123.3394 48.49139 0.0333333333
## 234 DSCN8289.JPG 2022:04:14 17:36:45 -123.3393 48.49134 0.0400000000
## 235 DSCN8290.JPG 2022:04:14 17:36:51 -123.3393 48.49133 0.0400000000
## 236 DSCN8292.JPG 2022:04:14 17:37:00 -123.3392 48.49132 0.0400000000
## 237 DSCN8293.JPG 2022:04:14 17:37:30 -123.3395 48.49129 0.0666666667
## 238 DSCN8294.JPG 2022:04:14 17:37:31 -123.3395 48.49129 0.0666666667
## 239 DSCN8295.JPG 2022:04:14 17:38:40 -123.3398 48.49117 0.0333333333
## 240 DSCN8296.JPG 2022:04:14 17:38:45 -123.3398 48.49115 0.0333333333
## 241 DSCN8298.JPG 2022:04:14 17:39:09 -123.3398 48.49118 0.0333333333
## 242 DSCN8299.JPG 2022:04:14 17:39:11 -123.3398 48.49117 0.0333333333
## 243 DSCN8304.JPG 2022:04:14 17:39:47 -123.3399 48.49123 0.0333333333
## 244 DSCN8306.JPG 2022:04:14 17:39:56 -123.3399 48.49127 0.0333333333
## 245 DSCN8308.JPG 2022:04:14 17:40:31 -123.3401 48.49125 0.0666666667
## 246 DSCN8309.JPG 2022:04:14 17:40:48 -123.3401 48.49119 0.0333333333
## 247 DSCN8310.JPG 2022:04:14 17:41:33 -123.3400 48.49099 0.0400000000
## 248 DSCN8312.JPG 2022:04:14 17:43:49 -123.3399 48.49101 0.0050000000
## 249 DSCN8314.JPG 2022:04:14 17:44:09 -123.3404 48.49117 0.0050000000
## 250 DSCN8315.JPG 2022:04:14 17:44:26 -123.3405 48.49117 0.1000000000
## 251 DSCN8316.JPG 2022:04:14 17:44:39 -123.3404 48.49106 0.0400000000
## 252 DSCN8317.JPG 2022:04:14 17:44:41 -123.3404 48.49107 0.0400000000
## 253 DSCN8320.JPG 2022:04:14 17:50:37 -123.3398 48.49123 0.0333333333
## 254 DSCN8324.JPG 2022:04:14 17:51:16 -123.3397 48.49128 0.0333333333
## 255 DSCN8328.JPG 2022:04:14 17:51:26 -123.3397 48.49126 0.0333333333
## 256 DSCN8330.JPG 2022:04:14 17:53:36 -123.3391 48.49155 0.0666666667
## 257 DSCN8333.JPG 2022:04:14 17:57:30 -123.3388 48.49129 0.0666666667
## 258 DSCN8334.JPG 2022:04:14 17:57:58 -123.3390 48.49148 0.0333333333
## FNumber ISO FocalLength
## 1 8.8 125 10.1
## 2 9.1 125 13.0
## 3 9.1 125 13.0
## 4 4.9 125 21.5
## 5 4.9 125 21.5
## 6 4.9 125 21.5
## 7 4.9 125 21.5
## 8 4.9 125 21.5
## 9 4.9 125 21.5
## 10 4.9 125 21.5
## 11 4.2 125 7.2
## 12 4.2 125 7.2
## 13 4.2 125 7.2
## 14 4.2 125 7.2
## 15 4.2 125 7.2
## 16 4.2 125 7.2
## 17 4.2 125 7.2
## 18 4.2 125 7.2
## 19 4.2 125 7.2
## 20 4.2 125 7.2
## 21 4.2 125 7.2
## 22 4.2 125 7.2
## 23 4.2 125 7.2
## 24 4.2 125 7.2
## 25 4.2 125 7.2
## 26 4.2 125 7.2
## 27 2.8 125 5.1
## 28 2.8 125 5.1
## 29 2.8 125 5.1
## 30 2.8 125 4.3
## 31 2.8 125 4.3
## 32 2.8 125 4.3
## 33 2.8 125 4.3
## 34 2.8 125 4.3
## 35 2.8 125 4.3
## 36 2.8 125 4.3
## 37 2.8 125 4.3
## 38 2.8 125 4.3
## 39 2.8 125 4.3
## 40 2.8 125 4.3
## 41 4.1 125 4.3
## 42 4.1 125 4.3
## 43 2.8 125 4.3
## 44 4.1 125 4.3
## 45 4.2 125 6.1
## 46 4.2 125 6.1
## 47 4.2 125 6.1
## 48 4.2 125 6.1
## 49 4.4 125 10.1
## 50 4.4 125 10.1
## 51 4.4 125 10.1
## 52 4.4 125 10.1
## 53 4.4 125 10.1
## 54 4.4 125 10.1
## 55 4.4 125 10.1
## 56 4.4 125 10.1
## 57 4.4 125 10.1
## 58 4.4 125 10.1
## 59 4.4 125 10.1
## 60 4.4 125 10.1
## 61 4.4 125 10.1
## 62 4.4 125 10.1
## 63 4.4 125 10.1
## 64 4.4 125 10.1
## 65 4.4 125 10.1
## 66 4.4 125 10.1
## 67 4.4 125 10.1
## 68 2.8 125 4.3
## 69 2.8 125 4.3
## 70 4.1 125 4.3
## 71 4.1 125 4.3
## 72 2.8 125 4.3
## 73 4.1 125 4.3
## 74 8.2 125 4.3
## 75 2.8 125 4.3
## 76 2.8 125 4.3
## 77 4.1 125 4.3
## 78 8.2 125 4.3
## 79 2.8 125 4.3
## 80 4.4 125 10.1
## 81 4.4 125 10.1
## 82 4.4 125 10.1
## 83 4.4 125 10.1
## 84 4.4 125 10.1
## 85 4.4 125 10.1
## 86 4.4 125 10.1
## 87 4.4 125 10.1
## 88 4.4 125 10.1
## 89 4.4 125 10.1
## 90 4.4 125 10.1
## 91 4.4 125 10.1
## 92 4.4 125 10.1
## 93 4.4 125 10.1
## 94 4.4 125 10.1
## 95 4.4 125 10.1
## 96 4.4 125 10.1
## 97 4.4 125 10.1
## 98 4.4 125 10.1
## 99 4.4 125 11.0
## 100 4.9 125 21.5
## 101 4.9 125 21.5
## 102 4.9 125 21.5
## 103 4.9 125 21.5
## 104 4.9 125 21.5
## 105 4.9 125 21.5
## 106 4.2 125 6.1
## 107 4.2 125 6.1
## 108 4.2 125 6.1
## 109 4.2 125 6.1
## 110 4.2 125 6.1
## 111 4.4 125 10.1
## 112 4.1 125 4.3
## 113 4.2 125 6.6
## 114 4.2 125 6.6
## 115 4.2 125 6.6
## 116 4.2 125 6.6
## 117 4.2 125 6.6
## 118 4.4 125 10.1
## 119 4.4 125 10.1
## 120 4.4 125 10.1
## 121 4.4 125 10.1
## 122 4.4 125 10.1
## 123 4.9 125 21.5
## 124 2.8 125 5.1
## 125 2.8 125 5.1
## 126 2.8 125 5.1
## 127 8.3 125 5.1
## 128 8.8 125 10.1
## 129 8.8 125 10.1
## 130 8.8 125 10.1
## 131 4.9 125 21.5
## 132 4.9 125 21.5
## 133 4.9 125 21.5
## 134 4.9 125 21.5
## 135 4.9 125 21.5
## 136 4.9 125 21.5
## 137 4.2 125 6.6
## 138 4.2 125 6.6
## 139 4.7 125 16.6
## 140 4.1 125 4.7
## 141 4.1 125 4.7
## 142 4.1 125 4.7
## 143 4.1 125 4.7
## 144 2.8 125 4.7
## 145 4.1 125 4.7
## 146 4.4 400 10.1
## 147 4.2 400 6.6
## 148 4.2 400 6.6
## 149 4.2 280 6.6
## 150 4.2 360 6.6
## 151 4.2 360 6.6
## 152 4.2 125 6.6
## 153 4.2 220 6.6
## 154 4.2 220 6.6
## 155 4.2 160 6.6
## 156 4.2 160 6.6
## 157 4.2 125 6.6
## 158 4.2 125 6.6
## 159 4.2 125 6.6
## 160 2.8 125 4.3
## 161 2.8 125 4.3
## 162 2.8 125 4.3
## 163 2.8 125 4.3
## 164 2.8 125 4.3
## 165 2.8 125 4.3
## 166 2.8 125 4.3
## 167 2.8 125 4.3
## 168 2.8 125 4.3
## 169 2.8 125 4.3
## 170 4.2 125 6.6
## 171 4.2 125 6.6
## 172 4.2 125 6.6
## 173 4.2 125 6.6
## 174 4.2 125 6.6
## 175 4.2 125 6.6
## 176 4.2 125 6.6
## 177 4.2 125 6.6
## 178 4.2 125 6.6
## 179 4.2 125 6.6
## 180 4.2 125 6.6
## 181 4.2 280 6.6
## 182 4.2 125 6.6
## 183 4.2 280 6.6
## 184 4.2 125 6.6
## 185 4.2 125 6.6
## 186 4.2 125 6.6
## 187 2.8 250 4.3
## 188 2.8 180 4.3
## 189 2.8 125 4.3
## 190 2.8 160 4.3
## 191 4.4 125 10.1
## 192 4.4 125 10.1
## 193 4.4 125 10.1
## 194 4.4 125 10.1
## 195 4.4 220 10.1
## 196 4.4 250 10.1
## 197 4.4 320 10.1
## 198 4.4 250 10.1
## 199 4.2 125 6.1
## 200 4.2 125 6.1
## 201 4.2 400 6.1
## 202 2.8 180 4.3
## 203 2.8 125 4.3
## 204 2.8 125 4.3
## 205 4.2 140 6.1
## 206 4.2 125 6.1
## 207 4.2 125 6.1
## 208 4.2 125 6.1
## 209 4.2 400 6.1
## 210 4.2 250 6.1
## 211 4.2 280 6.1
## 212 4.2 125 6.1
## 213 4.2 280 6.1
## 214 4.2 125 6.1
## 215 4.2 320 6.1
## 216 4.2 400 6.1
## 217 4.2 400 6.1
## 218 4.2 400 6.1
## 219 4.2 280 6.1
## 220 4.2 400 6.1
## 221 4.2 400 6.1
## 222 4.2 400 6.1
## 223 4.2 360 6.1
## 224 4.2 360 6.1
## 225 4.2 200 6.1
## 226 4.2 125 6.1
## 227 4.2 125 6.1
## 228 4.2 125 6.1
## 229 4.2 125 6.1
## 230 4.2 200 6.1
## 231 4.2 400 6.1
## 232 4.2 400 6.1
## 233 4.2 400 6.1
## 234 4.2 400 6.1
## 235 4.2 400 6.1
## 236 4.2 400 6.1
## 237 4.2 400 6.1
## 238 4.2 400 6.1
## 239 4.2 400 6.1
## 240 4.2 400 6.1
## 241 4.2 280 6.1
## 242 4.2 160 6.1
## 243 4.2 320 6.1
## 244 4.2 360 6.1
## 245 4.2 400 6.1
## 246 4.2 360 6.1
## 247 4.2 400 6.1
## 248 4.2 125 6.1
## 249 4.2 125 6.1
## 250 4.2 450 6.1
## 251 2.8 400 4.3
## 252 2.8 400 4.3
## 253 4.4 220 10.1
## 254 4.4 400 10.1
## 255 4.4 220 10.1
## 256 4.4 400 10.1
## 257 4.8 900 18.1
## 258 2.8 200 5.13.1.1 Rename columns
colnames(exif)## [1] "SourceFile" "DateTimeOriginal" "GPSLongitude" "GPSLatitude"
## [5] "ExposureTime" "FNumber" "ISO" "FocalLength"names(exif)[1] <- "Image"
names(exif)[2] <- "Date"
names(exif)[3] <- "Longitude"
names(exif)[4] <- "Latitude"
names(exif)[5] <- "Exposure"
names(exif)[6] <- "F-Stop"
names(exif)[7] <- "ISO"
names(exif)[8] <- "Focal"
colnames(exif)## [1] "Image" "Date" "Longitude" "Latitude" "Exposure" "F-Stop"
## [7] "ISO" "Focal"3.1.2 Add column
exif$Desc <- ""
exif$Name <- ""
exif$Location <- "Mt. Douglas"
str(exif)## 'data.frame': 258 obs. of 11 variables:
## $ Image : chr "DSCN7961.JPG" "DSCN7962.JPG" "DSCN7963.JPG" "DSCN7965.JPG" ...
## $ Date : chr "2022:04:14 14:21:41" "2022:04:14 14:21:47" "2022:04:14 14:21:54" "2022:04:14 14:50:57" ...
## $ Longitude: num NA NA NA -123 -123 ...
## $ Latitude : num NA NA NA 48.5 48.5 ...
## $ Exposure : num 0.002 0.002 0.002 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 ...
## $ F-Stop : num 8.8 9.1 9.1 4.9 4.9 4.9 4.9 4.9 4.9 4.9 ...
## $ ISO : int 125 125 125 125 125 125 125 125 125 125 ...
## $ Focal : num 10.1 13 13 21.5 21.5 21.5 21.5 21.5 21.5 21.5 ...
## $ Desc : chr "" "" "" "" ...
## $ Name : chr "" "" "" "" ...
## $ Location : chr "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" ...3.2 Convert Date to time format
exif$Date <- lubridate::ymd_hms(exif$Date, tz=Sys.timezone())
str(exif)## 'data.frame': 258 obs. of 11 variables:
## $ Image : chr "DSCN7961.JPG" "DSCN7962.JPG" "DSCN7963.JPG" "DSCN7965.JPG" ...
## $ Date : POSIXct, format: "2022-04-14 14:21:41" "2022-04-14 14:21:47" ...
## $ Longitude: num NA NA NA -123 -123 ...
## $ Latitude : num NA NA NA 48.5 48.5 ...
## $ Exposure : num 0.002 0.002 0.002 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 ...
## $ F-Stop : num 8.8 9.1 9.1 4.9 4.9 4.9 4.9 4.9 4.9 4.9 ...
## $ ISO : int 125 125 125 125 125 125 125 125 125 125 ...
## $ Focal : num 10.1 13 13 21.5 21.5 21.5 21.5 21.5 21.5 21.5 ...
## $ Desc : chr "" "" "" "" ...
## $ Name : chr "" "" "" "" ...
## $ Location : chr "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" ...3.3 add data to Name & Desc columns
head(exif)## Image Date Longitude Latitude Exposure F-Stop ISO Focal
## 1 DSCN7961.JPG 2022-04-14 14:21:41 NA NA 0.0020 8.8 125 10.1
## 2 DSCN7962.JPG 2022-04-14 14:21:47 NA NA 0.0020 9.1 125 13.0
## 3 DSCN7963.JPG 2022-04-14 14:21:54 NA NA 0.0020 9.1 125 13.0
## 4 DSCN7965.JPG 2022-04-14 14:50:57 -123.3453 48.49260 0.0025 4.9 125 21.5
## 5 DSCN7966.JPG 2022-04-14 14:51:05 -123.3452 48.49255 0.0025 4.9 125 21.5
## 6 DSCN7967.JPG 2022-04-14 14:51:11 -123.3452 48.49252 0.0025 4.9 125 21.5
## Desc Name Location
## 1 Mt. Douglas
## 2 Mt. Douglas
## 3 Mt. Douglas
## 4 Mt. Douglas
## 5 Mt. Douglas
## 6 Mt. Douglasexif_rows <- row.names(exif)
print(exif_rows)## [1] "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12"
## [13] "13" "14" "15" "16" "17" "18" "19" "20" "21" "22" "23" "24"
## [25] "25" "26" "27" "28" "29" "30" "31" "32" "33" "34" "35" "36"
## [37] "37" "38" "39" "40" "41" "42" "43" "44" "45" "46" "47" "48"
## [49] "49" "50" "51" "52" "53" "54" "55" "56" "57" "58" "59" "60"
## [61] "61" "62" "63" "64" "65" "66" "67" "68" "69" "70" "71" "72"
## [73] "73" "74" "75" "76" "77" "78" "79" "80" "81" "82" "83" "84"
## [85] "85" "86" "87" "88" "89" "90" "91" "92" "93" "94" "95" "96"
## [97] "97" "98" "99" "100" "101" "102" "103" "104" "105" "106" "107" "108"
## [109] "109" "110" "111" "112" "113" "114" "115" "116" "117" "118" "119" "120"
## [121] "121" "122" "123" "124" "125" "126" "127" "128" "129" "130" "131" "132"
## [133] "133" "134" "135" "136" "137" "138" "139" "140" "141" "142" "143" "144"
## [145] "145" "146" "147" "148" "149" "150" "151" "152" "153" "154" "155" "156"
## [157] "157" "158" "159" "160" "161" "162" "163" "164" "165" "166" "167" "168"
## [169] "169" "170" "171" "172" "173" "174" "175" "176" "177" "178" "179" "180"
## [181] "181" "182" "183" "184" "185" "186" "187" "188" "189" "190" "191" "192"
## [193] "193" "194" "195" "196" "197" "198" "199" "200" "201" "202" "203" "204"
## [205] "205" "206" "207" "208" "209" "210" "211" "212" "213" "214" "215" "216"
## [217] "217" "218" "219" "220" "221" "222" "223" "224" "225" "226" "227" "228"
## [229] "229" "230" "231" "232" "233" "234" "235" "236" "237" "238" "239" "240"
## [241] "241" "242" "243" "244" "245" "246" "247" "248" "249" "250" "251" "252"
## [253] "253" "254" "255" "256" "257" "258"str(exif_rows)## chr [1:258] "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" "13" "14" ...exif$Image## [1] "DSCN7961.JPG" "DSCN7962.JPG" "DSCN7963.JPG"
## [4] "DSCN7965.JPG" "DSCN7966.JPG" "DSCN7967.JPG"
## [7] "DSCN7968.JPG" "DSCN7969.JPG" "DSCN7970 copy.JPG"
## [10] "DSCN7970.JPG" "DSCN7971.JPG" "DSCN7973.JPG"
## [13] "DSCN7975.JPG" "DSCN7977.JPG" "DSCN7978.JPG"
## [16] "DSCN7979.JPG" "DSCN7980.JPG" "DSCN7982.JPG"
## [19] "DSCN7983.JPG" "DSCN7984.JPG" "DSCN7985.JPG"
## [22] "DSCN7987.JPG" "DSCN7988.JPG" "DSCN7989.JPG"
## [25] "DSCN7991.JPG" "DSCN7992.JPG" "DSCN7999.JPG"
## [28] "DSCN8000.JPG" "DSCN8002.JPG" "DSCN8004.JPG"
## [31] "DSCN8005.JPG" "DSCN8006.JPG" "DSCN8007.JPG"
## [34] "DSCN8008.JPG" "DSCN8009.JPG" "DSCN8011.JPG"
## [37] "DSCN8012.JPG" "DSCN8013.JPG" "DSCN8014.JPG"
## [40] "DSCN8017.JPG" "DSCN8018.JPG" "DSCN8019.JPG"
## [43] "DSCN8020.JPG" "DSCN8021.JPG" "DSCN8023.JPG"
## [46] "DSCN8024.JPG" "DSCN8025.JPG" "DSCN8026.JPG"
## [49] "DSCN8027.JPG" "DSCN8030.JPG" "DSCN8031.JPG"
## [52] "DSCN8032.JPG" "DSCN8034.JPG" "DSCN8036.JPG"
## [55] "DSCN8038.JPG" "DSCN8039.JPG" "DSCN8040.JPG"
## [58] "DSCN8041.JPG" "DSCN8042.JPG" "DSCN8044.JPG"
## [61] "DSCN8045.JPG" "DSCN8046.JPG" "DSCN8047.JPG"
## [64] "DSCN8048.JPG" "DSCN8050.JPG" "DSCN8051.JPG"
## [67] "DSCN8052.JPG" "DSCN8053.JPG" "DSCN8054.JPG"
## [70] "DSCN8055.JPG" "DSCN8056.JPG" "DSCN8057.JPG"
## [73] "DSCN8058.JPG" "DSCN8059.JPG" "DSCN8060.JPG"
## [76] "DSCN8061.JPG" "DSCN8062.JPG" "DSCN8063.JPG"
## [79] "DSCN8064.JPG" "DSCN8065.JPG" "DSCN8066.JPG"
## [82] "DSCN8067 copy.JPG" "DSCN8067.JPG" "DSCN8068.JPG"
## [85] "DSCN8069.JPG" "DSCN8070.JPG" "DSCN8071.JPG"
## [88] "DSCN8072.JPG" "DSCN8073.JPG" "DSCN8074 copy.JPG"
## [91] "DSCN8074.JPG" "DSCN8076 copy.JPG" "DSCN8076.JPG"
## [94] "DSCN8079.JPG" "DSCN8080.JPG" "DSCN8082.JPG"
## [97] "DSCN8084.JPG" "DSCN8085.JPG" "DSCN8088.JPG"
## [100] "DSCN8089.JPG" "DSCN8091.JPG" "DSCN8092.JPG"
## [103] "DSCN8094.JPG" "DSCN8095 copy.JPG" "DSCN8095.JPG"
## [106] "DSCN8097.JPG" "DSCN8098.JPG" "DSCN8099.JPG"
## [109] "DSCN8100.JPG" "DSCN8101.JPG" "DSCN8102.JPG"
## [112] "DSCN8103.JPG" "DSCN8104.JPG" "DSCN8105.JPG"
## [115] "DSCN8107.JPG" "DSCN8108.JPG" "DSCN8109.JPG"
## [118] "DSCN8110.JPG" "DSCN8111.JPG" "DSCN8112.JPG"
## [121] "DSCN8114.JPG" "DSCN8115.JPG" "DSCN8117.JPG"
## [124] "DSCN8118.JPG" "DSCN8119.JPG" "DSCN8120.JPG"
## [127] "DSCN8121.JPG" "DSCN8122.JPG" "DSCN8123.JPG"
## [130] "DSCN8124.JPG" "DSCN8128.JPG" "DSCN8131.JPG"
## [133] "DSCN8132.JPG" "DSCN8133.JPG" "DSCN8134.JPG"
## [136] "DSCN8135.JPG" "DSCN8136.JPG" "DSCN8137.JPG"
## [139] "DSCN8138.JPG" "DSCN8141.JPG" "DSCN8142.JPG"
## [142] "DSCN8143.JPG" "DSCN8146.JPG" "DSCN8147.JPG"
## [145] "DSCN8148.JPG" "DSCN8149.JPG" "DSCN8150.JPG"
## [148] "DSCN8151.JPG" "DSCN8152.JPG" "DSCN8153.JPG"
## [151] "DSCN8154.JPG" "DSCN8156.JPG" "DSCN8157.JPG"
## [154] "DSCN8158.JPG" "DSCN8161.JPG" "DSCN8162.JPG"
## [157] "DSCN8163.JPG" "DSCN8164.JPG" "DSCN8165.JPG"
## [160] "DSCN8167.JPG" "DSCN8168.JPG" "DSCN8169.JPG"
## [163] "DSCN8170.JPG" "DSCN8171.JPG" "DSCN8172.JPG"
## [166] "DSCN8174.JPG" "DSCN8175.JPG" "DSCN8176.JPG"
## [169] "DSCN8177.JPG" "DSCN8180.JPG" "DSCN8182.JPG"
## [172] "DSCN8183.JPG" "DSCN8184.JPG" "DSCN8185.JPG"
## [175] "DSCN8188.JPG" "DSCN8189.JPG" "DSCN8191.JPG"
## [178] "DSCN8192.JPG" "DSCN8196.JPG" "DSCN8198.JPG"
## [181] "DSCN8199.JPG" "DSCN8200.JPG" "DSCN8201.JPG"
## [184] "DSCN8202.JPG" "DSCN8203.JPG" "DSCN8204.JPG"
## [187] "DSCN8205.JPG" "DSCN8206.JPG" "DSCN8207.JPG"
## [190] "DSCN8208.JPG" "DSCN8209.JPG" "DSCN8211.JPG"
## [193] "DSCN8212.JPG" "DSCN8213.JPG" "DSCN8215.JPG"
## [196] "DSCN8216.JPG" "DSCN8217.JPG" "DSCN8218.JPG"
## [199] "DSCN8219.JPG" "DSCN8220.JPG" "DSCN8221.JPG"
## [202] "DSCN8222.JPG" "DSCN8223.JPG" "DSCN8225.JPG"
## [205] "DSCN8227.JPG" "DSCN8229.JPG" "DSCN8230.JPG"
## [208] "DSCN8231.JPG" "DSCN8232.JPG" "DSCN8234.JPG"
## [211] "DSCN8236.JPG" "DSCN8237.JPG" "DSCN8238.JPG"
## [214] "DSCN8239.JPG" "DSCN8242.JPG" "DSCN8244.JPG"
## [217] "DSCN8245.JPG" "DSCN8246.JPG" "DSCN8247.JPG"
## [220] "DSCN8248.JPG" "DSCN8251.JPG" "DSCN8255.JPG"
## [223] "DSCN8258.JPG" "DSCN8259.JPG" "DSCN8275.JPG"
## [226] "DSCN8276.JPG" "DSCN8277.JPG" "DSCN8280.JPG"
## [229] "DSCN8281.JPG" "DSCN8283.JPG" "DSCN8285.JPG"
## [232] "DSCN8287.JPG" "DSCN8288.JPG" "DSCN8289.JPG"
## [235] "DSCN8290.JPG" "DSCN8292.JPG" "DSCN8293.JPG"
## [238] "DSCN8294.JPG" "DSCN8295.JPG" "DSCN8296.JPG"
## [241] "DSCN8298.JPG" "DSCN8299.JPG" "DSCN8304.JPG"
## [244] "DSCN8306.JPG" "DSCN8308.JPG" "DSCN8309.JPG"
## [247] "DSCN8310.JPG" "DSCN8312.JPG" "DSCN8314.JPG"
## [250] "DSCN8315.JPG" "DSCN8316.JPG" "DSCN8317.JPG"
## [253] "DSCN8320.JPG" "DSCN8324.JPG" "DSCN8328.JPG"
## [256] "DSCN8330.JPG" "DSCN8333.JPG" "DSCN8334.JPG"# try to name 2 rows at once >> using c()
exif[c("4", "5", "6", "7", "8", "9", "10"), "Name"] <- "Bee Fly" # 4-10
exif[c("11", "14", "17"), "Name"] <- "Fawn Lily" # 11, 14, 17
exif["13", "Name"] <- "Miners Lettuce" # 13
exif[c("15", "16"), "Name"] <- "Licorice Fern" # 15, 16
exif[c("18", "19", "20", "21", "39", "40"), "Name"] <- "Monkey Flower" # 18, 19, 20, 21
exif[c("26", "27", "27", "27", "30", "31", "32", "33"), "Name"] <- "Chocolate Lily" # 26, 27, 28, 29, 30, 31, 32, 33
exif[c("4", "5", "6", "7", "8", "9", "10"), "Desc"] <- "BF" #"Bee Fly" # 4-10
exif[c("11", "14", "17"), "Desc"] <- "FL" # "Fawn Lily" # 11, 14, 17
exif["13", "Desc"] <- "ML" #"Miner's Lettuce" # 13
exif[c("15", "16"), "Desc"] <- "LF" #"Licorice Fern" # 15, 16
exif[c("18", "19", "20", "21"), "Desc"] <- "MF" # "Monkey Flower" # 18, 19, 20, 21
exif[c("26", "27", "27", "27", "30", "31", "32", "33"), "Desc"] <- "CL" #"Chocolate Lily" # 26, 27, 28, 29, 30, 31, 32, 33
exif_rows_list <- exif[, c("Image", "Name", "Desc")]
exif_rows_list## Image Name Desc
## 1 DSCN7961.JPG
## 2 DSCN7962.JPG
## 3 DSCN7963.JPG
## 4 DSCN7965.JPG Bee Fly BF
## 5 DSCN7966.JPG Bee Fly BF
## 6 DSCN7967.JPG Bee Fly BF
## 7 DSCN7968.JPG Bee Fly BF
## 8 DSCN7969.JPG Bee Fly BF
## 9 DSCN7970 copy.JPG Bee Fly BF
## 10 DSCN7970.JPG Bee Fly BF
## 11 DSCN7971.JPG Fawn Lily FL
## 12 DSCN7973.JPG
## 13 DSCN7975.JPG Miners Lettuce ML
## 14 DSCN7977.JPG Fawn Lily FL
## 15 DSCN7978.JPG Licorice Fern LF
## 16 DSCN7979.JPG Licorice Fern LF
## 17 DSCN7980.JPG Fawn Lily FL
## 18 DSCN7982.JPG Monkey Flower MF
## 19 DSCN7983.JPG Monkey Flower MF
## 20 DSCN7984.JPG Monkey Flower MF
## 21 DSCN7985.JPG Monkey Flower MF
## 22 DSCN7987.JPG
## 23 DSCN7988.JPG
## 24 DSCN7989.JPG
## 25 DSCN7991.JPG
## 26 DSCN7992.JPG Chocolate Lily CL
## 27 DSCN7999.JPG Chocolate Lily CL
## 28 DSCN8000.JPG
## 29 DSCN8002.JPG
## 30 DSCN8004.JPG Chocolate Lily CL
## 31 DSCN8005.JPG Chocolate Lily CL
## 32 DSCN8006.JPG Chocolate Lily CL
## 33 DSCN8007.JPG Chocolate Lily CL
## 34 DSCN8008.JPG
## 35 DSCN8009.JPG
## 36 DSCN8011.JPG
## 37 DSCN8012.JPG
## 38 DSCN8013.JPG
## 39 DSCN8014.JPG Monkey Flower
## 40 DSCN8017.JPG Monkey Flower
## 41 DSCN8018.JPG
## 42 DSCN8019.JPG
## 43 DSCN8020.JPG
## 44 DSCN8021.JPG
## 45 DSCN8023.JPG
## 46 DSCN8024.JPG
## 47 DSCN8025.JPG
## 48 DSCN8026.JPG
## 49 DSCN8027.JPG
## 50 DSCN8030.JPG
## 51 DSCN8031.JPG
## 52 DSCN8032.JPG
## 53 DSCN8034.JPG
## 54 DSCN8036.JPG
## 55 DSCN8038.JPG
## 56 DSCN8039.JPG
## 57 DSCN8040.JPG
## 58 DSCN8041.JPG
## 59 DSCN8042.JPG
## 60 DSCN8044.JPG
## 61 DSCN8045.JPG
## 62 DSCN8046.JPG
## 63 DSCN8047.JPG
## 64 DSCN8048.JPG
## 65 DSCN8050.JPG
## 66 DSCN8051.JPG
## 67 DSCN8052.JPG
## 68 DSCN8053.JPG
## 69 DSCN8054.JPG
## 70 DSCN8055.JPG
## 71 DSCN8056.JPG
## 72 DSCN8057.JPG
## 73 DSCN8058.JPG
## 74 DSCN8059.JPG
## 75 DSCN8060.JPG
## 76 DSCN8061.JPG
## 77 DSCN8062.JPG
## 78 DSCN8063.JPG
## 79 DSCN8064.JPG
## 80 DSCN8065.JPG
## 81 DSCN8066.JPG
## 82 DSCN8067 copy.JPG
## 83 DSCN8067.JPG
## 84 DSCN8068.JPG
## 85 DSCN8069.JPG
## 86 DSCN8070.JPG
## 87 DSCN8071.JPG
## 88 DSCN8072.JPG
## 89 DSCN8073.JPG
## 90 DSCN8074 copy.JPG
## 91 DSCN8074.JPG
## 92 DSCN8076 copy.JPG
## 93 DSCN8076.JPG
## 94 DSCN8079.JPG
## 95 DSCN8080.JPG
## 96 DSCN8082.JPG
## 97 DSCN8084.JPG
## 98 DSCN8085.JPG
## 99 DSCN8088.JPG
## 100 DSCN8089.JPG
## 101 DSCN8091.JPG
## 102 DSCN8092.JPG
## 103 DSCN8094.JPG
## 104 DSCN8095 copy.JPG
## 105 DSCN8095.JPG
## 106 DSCN8097.JPG
## 107 DSCN8098.JPG
## 108 DSCN8099.JPG
## 109 DSCN8100.JPG
## 110 DSCN8101.JPG
## 111 DSCN8102.JPG
## 112 DSCN8103.JPG
## 113 DSCN8104.JPG
## 114 DSCN8105.JPG
## 115 DSCN8107.JPG
## 116 DSCN8108.JPG
## 117 DSCN8109.JPG
## 118 DSCN8110.JPG
## 119 DSCN8111.JPG
## 120 DSCN8112.JPG
## 121 DSCN8114.JPG
## 122 DSCN8115.JPG
## 123 DSCN8117.JPG
## 124 DSCN8118.JPG
## 125 DSCN8119.JPG
## 126 DSCN8120.JPG
## 127 DSCN8121.JPG
## 128 DSCN8122.JPG
## 129 DSCN8123.JPG
## 130 DSCN8124.JPG
## 131 DSCN8128.JPG
## 132 DSCN8131.JPG
## 133 DSCN8132.JPG
## 134 DSCN8133.JPG
## 135 DSCN8134.JPG
## 136 DSCN8135.JPG
## 137 DSCN8136.JPG
## 138 DSCN8137.JPG
## 139 DSCN8138.JPG
## 140 DSCN8141.JPG
## 141 DSCN8142.JPG
## 142 DSCN8143.JPG
## 143 DSCN8146.JPG
## 144 DSCN8147.JPG
## 145 DSCN8148.JPG
## 146 DSCN8149.JPG
## 147 DSCN8150.JPG
## 148 DSCN8151.JPG
## 149 DSCN8152.JPG
## 150 DSCN8153.JPG
## 151 DSCN8154.JPG
## 152 DSCN8156.JPG
## 153 DSCN8157.JPG
## 154 DSCN8158.JPG
## 155 DSCN8161.JPG
## 156 DSCN8162.JPG
## 157 DSCN8163.JPG
## 158 DSCN8164.JPG
## 159 DSCN8165.JPG
## 160 DSCN8167.JPG
## 161 DSCN8168.JPG
## 162 DSCN8169.JPG
## 163 DSCN8170.JPG
## 164 DSCN8171.JPG
## 165 DSCN8172.JPG
## 166 DSCN8174.JPG
## 167 DSCN8175.JPG
## 168 DSCN8176.JPG
## 169 DSCN8177.JPG
## 170 DSCN8180.JPG
## 171 DSCN8182.JPG
## 172 DSCN8183.JPG
## 173 DSCN8184.JPG
## 174 DSCN8185.JPG
## 175 DSCN8188.JPG
## 176 DSCN8189.JPG
## 177 DSCN8191.JPG
## 178 DSCN8192.JPG
## 179 DSCN8196.JPG
## 180 DSCN8198.JPG
## 181 DSCN8199.JPG
## 182 DSCN8200.JPG
## 183 DSCN8201.JPG
## 184 DSCN8202.JPG
## 185 DSCN8203.JPG
## 186 DSCN8204.JPG
## 187 DSCN8205.JPG
## 188 DSCN8206.JPG
## 189 DSCN8207.JPG
## 190 DSCN8208.JPG
## 191 DSCN8209.JPG
## 192 DSCN8211.JPG
## 193 DSCN8212.JPG
## 194 DSCN8213.JPG
## 195 DSCN8215.JPG
## 196 DSCN8216.JPG
## 197 DSCN8217.JPG
## 198 DSCN8218.JPG
## 199 DSCN8219.JPG
## 200 DSCN8220.JPG
## 201 DSCN8221.JPG
## 202 DSCN8222.JPG
## 203 DSCN8223.JPG
## 204 DSCN8225.JPG
## 205 DSCN8227.JPG
## 206 DSCN8229.JPG
## 207 DSCN8230.JPG
## 208 DSCN8231.JPG
## 209 DSCN8232.JPG
## 210 DSCN8234.JPG
## 211 DSCN8236.JPG
## 212 DSCN8237.JPG
## 213 DSCN8238.JPG
## 214 DSCN8239.JPG
## 215 DSCN8242.JPG
## 216 DSCN8244.JPG
## 217 DSCN8245.JPG
## 218 DSCN8246.JPG
## 219 DSCN8247.JPG
## 220 DSCN8248.JPG
## 221 DSCN8251.JPG
## 222 DSCN8255.JPG
## 223 DSCN8258.JPG
## 224 DSCN8259.JPG
## 225 DSCN8275.JPG
## 226 DSCN8276.JPG
## 227 DSCN8277.JPG
## 228 DSCN8280.JPG
## 229 DSCN8281.JPG
## 230 DSCN8283.JPG
## 231 DSCN8285.JPG
## 232 DSCN8287.JPG
## 233 DSCN8288.JPG
## 234 DSCN8289.JPG
## 235 DSCN8290.JPG
## 236 DSCN8292.JPG
## 237 DSCN8293.JPG
## 238 DSCN8294.JPG
## 239 DSCN8295.JPG
## 240 DSCN8296.JPG
## 241 DSCN8298.JPG
## 242 DSCN8299.JPG
## 243 DSCN8304.JPG
## 244 DSCN8306.JPG
## 245 DSCN8308.JPG
## 246 DSCN8309.JPG
## 247 DSCN8310.JPG
## 248 DSCN8312.JPG
## 249 DSCN8314.JPG
## 250 DSCN8315.JPG
## 251 DSCN8316.JPG
## 252 DSCN8317.JPG
## 253 DSCN8320.JPG
## 254 DSCN8324.JPG
## 255 DSCN8328.JPG
## 256 DSCN8330.JPG
## 257 DSCN8333.JPG
## 258 DSCN8334.JPG3.4 Sort data by Image
class(exif)## [1] "data.frame"exif_sort <- exif[order(exif$Image, decreasing = FALSE), ]4 {jsonlite} create json object from all data
exif_json <- toJSON(exif_sort)
exif_json## [{"Image":"DSCN7961.JPG","Date":"2022-04-14 14:21:41","Exposure":0.002,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7962.JPG","Date":"2022-04-14 14:21:47","Exposure":0.002,"F-Stop":9.1,"ISO":125,"Focal":13,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7963.JPG","Date":"2022-04-14 14:21:54","Exposure":0.002,"F-Stop":9.1,"ISO":125,"Focal":13,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7973.JPG","Date":"2022-04-14 14:52:30","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7987.JPG","Date":"2022-04-14 14:56:31","Longitude":-123.3454,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7988.JPG","Date":"2022-04-14 14:56:33","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7989.JPG","Date":"2022-04-14 14:56:36","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7991.JPG","Date":"2022-04-14 14:56:47","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8000.JPG","Date":"2022-04-14 14:58:27","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8002.JPG","Date":"2022-04-14 14:58:35","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8008.JPG","Date":"2022-04-14 15:00:58","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8009.JPG","Date":"2022-04-14 15:01:04","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8011.JPG","Date":"2022-04-14 15:01:37","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8012.JPG","Date":"2022-04-14 15:01:40","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8013.JPG","Date":"2022-04-14 15:01:56","Longitude":-123.3457,"Latitude":48.493,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8018.JPG","Date":"2022-04-14 15:03:25","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8019.JPG","Date":"2022-04-14 15:03:26","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8020.JPG","Date":"2022-04-14 15:03:42","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8021.JPG","Date":"2022-04-14 15:04:05","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8023.JPG","Date":"2022-04-14 15:04:31","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8024.JPG","Date":"2022-04-14 15:04:46","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8025.JPG","Date":"2022-04-14 15:04:47","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0016,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8026.JPG","Date":"2022-04-14 15:06:58","Longitude":-123.346,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8027.JPG","Date":"2022-04-14 15:07:27","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8030.JPG","Date":"2022-04-14 15:07:58","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8031.JPG","Date":"2022-04-14 15:08:37","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8032.JPG","Date":"2022-04-14 15:08:42","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8034.JPG","Date":"2022-04-14 15:09:19","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8036.JPG","Date":"2022-04-14 15:09:21","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8038.JPG","Date":"2022-04-14 15:09:25","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8039.JPG","Date":"2022-04-14 15:10:19","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0062,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8040.JPG","Date":"2022-04-14 15:10:21","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0062,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8041.JPG","Date":"2022-04-14 15:10:25","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8042.JPG","Date":"2022-04-14 15:10:26","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8044.JPG","Date":"2022-04-14 15:10:35","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8045.JPG","Date":"2022-04-14 15:10:37","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8046.JPG","Date":"2022-04-14 15:10:39","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8047.JPG","Date":"2022-04-14 15:10:44","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8048.JPG","Date":"2022-04-14 15:14:35","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8050.JPG","Date":"2022-04-14 15:14:40","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8051.JPG","Date":"2022-04-14 15:14:44","Longitude":-123.3459,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8052.JPG","Date":"2022-04-14 15:40:05","Longitude":-123.3458,"Latitude":48.493,"Exposure":0.0167,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8053.JPG","Date":"2022-04-14 15:40:15","Longitude":-123.3461,"Latitude":48.4928,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8054.JPG","Date":"2022-04-14 15:45:12","Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8055.JPG","Date":"2022-04-14 15:45:15","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8056.JPG","Date":"2022-04-14 15:45:17","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8057.JPG","Date":"2022-04-14 15:45:20","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8058.JPG","Date":"2022-04-14 15:46:11","Longitude":-123.3462,"Latitude":48.4928,"Exposure":0.0008,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8059.JPG","Date":"2022-04-14 15:46:14","Longitude":-123.3462,"Latitude":48.4928,"Exposure":0.0016,"F-Stop":8.2,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8060.JPG","Date":"2022-04-14 15:47:56","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.004,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8061.JPG","Date":"2022-04-14 15:48:07","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8062.JPG","Date":"2022-04-14 15:48:15","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0007,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8063.JPG","Date":"2022-04-14 15:48:28","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":8.2,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8064.JPG","Date":"2022-04-14 15:49:12","Longitude":-123.3465,"Latitude":48.493,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8065.JPG","Date":"2022-04-14 15:53:39","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8066.JPG","Date":"2022-04-14 15:53:43","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8067 copy.JPG","Date":"2022-04-14 15:53:46","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8067.JPG","Date":"2022-04-14 15:53:46","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8068.JPG","Date":"2022-04-14 15:53:52","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8069.JPG","Date":"2022-04-14 15:53:55","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8070.JPG","Date":"2022-04-14 15:53:59","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8071.JPG","Date":"2022-04-14 15:55:14","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8072.JPG","Date":"2022-04-14 15:55:17","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8073.JPG","Date":"2022-04-14 15:55:49","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8074 copy.JPG","Date":"2022-04-14 15:56:06","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8074.JPG","Date":"2022-04-14 15:56:06","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8076 copy.JPG","Date":"2022-04-14 15:56:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8076.JPG","Date":"2022-04-14 15:56:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8079.JPG","Date":"2022-04-14 15:57:04","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.002,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8080.JPG","Date":"2022-04-14 15:57:29","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8082.JPG","Date":"2022-04-14 15:57:52","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.002,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8084.JPG","Date":"2022-04-14 15:58:14","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8085.JPG","Date":"2022-04-14 15:58:16","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8088.JPG","Date":"2022-04-14 16:02:18","Longitude":-123.3469,"Latitude":48.493,"Exposure":0.005,"F-Stop":4.4,"ISO":125,"Focal":11,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8089.JPG","Date":"2022-04-14 16:02:22","Longitude":-123.3469,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8091.JPG","Date":"2022-04-14 16:03:26","Longitude":-123.3467,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8092.JPG","Date":"2022-04-14 16:03:38","Longitude":-123.3467,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8094.JPG","Date":"2022-04-14 16:04:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8095 copy.JPG","Date":"2022-04-14 16:04:25","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8095.JPG","Date":"2022-04-14 16:04:25","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8097.JPG","Date":"2022-04-14 16:06:02","Longitude":-123.3465,"Latitude":48.4931,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8098.JPG","Date":"2022-04-14 16:06:03","Longitude":-123.3465,"Latitude":48.4931,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8099.JPG","Date":"2022-04-14 16:06:07","Longitude":-123.3466,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8100.JPG","Date":"2022-04-14 16:06:12","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8101.JPG","Date":"2022-04-14 16:06:16","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8102.JPG","Date":"2022-04-14 16:11:02","Longitude":-123.3465,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8103.JPG","Date":"2022-04-14 16:11:14","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.0008,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8104.JPG","Date":"2022-04-14 16:11:30","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.001,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8105.JPG","Date":"2022-04-14 16:11:46","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8107.JPG","Date":"2022-04-14 16:15:18","Longitude":-123.3463,"Latitude":48.4927,"Exposure":0.0008,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8108.JPG","Date":"2022-04-14 16:19:37","Longitude":-123.3464,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8109.JPG","Date":"2022-04-14 16:19:40","Longitude":-123.3464,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8110.JPG","Date":"2022-04-14 16:26:36","Longitude":-123.3449,"Latitude":48.4924,"Exposure":0.0125,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8111.JPG","Date":"2022-04-14 16:26:40","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.01,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8112.JPG","Date":"2022-04-14 16:26:46","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.001,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8114.JPG","Date":"2022-04-14 16:26:49","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8115.JPG","Date":"2022-04-14 16:32:13","Longitude":-123.3448,"Latitude":48.4919,"Exposure":0.001,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8117.JPG","Date":"2022-04-14 16:32:40","Longitude":-123.3448,"Latitude":48.4919,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8118.JPG","Date":"2022-04-14 16:34:46","Longitude":-123.3449,"Latitude":48.4919,"Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8119.JPG","Date":"2022-04-14 16:34:50","Longitude":-123.345,"Latitude":48.4917,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8120.JPG","Date":"2022-04-14 16:34:56","Longitude":-123.345,"Latitude":48.4918,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8121.JPG","Date":"2022-04-14 16:35:05","Longitude":-123.3449,"Latitude":48.4918,"Exposure":0.0016,"F-Stop":8.3,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8122.JPG","Date":"2022-04-14 16:35:10","Longitude":-123.3449,"Latitude":48.4918,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8123.JPG","Date":"2022-04-14 16:35:12","Longitude":-123.3449,"Latitude":48.4917,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8124.JPG","Date":"2022-04-14 16:35:13","Longitude":-123.3449,"Latitude":48.4917,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8128.JPG","Date":"2022-04-14 16:38:11","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8131.JPG","Date":"2022-04-14 16:38:21","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8132.JPG","Date":"2022-04-14 16:38:24","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8133.JPG","Date":"2022-04-14 16:38:26","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8134.JPG","Date":"2022-04-14 16:38:28","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8135.JPG","Date":"2022-04-14 16:38:29","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8136.JPG","Date":"2022-04-14 16:38:46","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8137.JPG","Date":"2022-04-14 16:39:08","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8138.JPG","Date":"2022-04-14 16:39:12","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.0031,"F-Stop":4.7,"ISO":125,"Focal":16.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8141.JPG","Date":"2022-04-14 16:39:56","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8142.JPG","Date":"2022-04-14 16:39:57","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8143.JPG","Date":"2022-04-14 16:40:07","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8146.JPG","Date":"2022-04-14 16:40:13","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8147.JPG","Date":"2022-04-14 16:41:03","Longitude":-123.3449,"Latitude":48.4923,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8148.JPG","Date":"2022-04-14 16:41:22","Longitude":-123.3448,"Latitude":48.4923,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8149.JPG","Date":"2022-04-14 16:50:02","Longitude":-123.345,"Latitude":48.4925,"Exposure":0.04,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8150.JPG","Date":"2022-04-14 16:50:29","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8151.JPG","Date":"2022-04-14 16:50:35","Longitude":-123.3428,"Latitude":48.4962,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8152.JPG","Date":"2022-04-14 16:50:51","Longitude":-123.3427,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8153.JPG","Date":"2022-04-14 16:51:42","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8154.JPG","Date":"2022-04-14 16:51:48","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8156.JPG","Date":"2022-04-14 16:52:24","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8157.JPG","Date":"2022-04-14 16:52:47","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":220,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8158.JPG","Date":"2022-04-14 16:52:51","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":220,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8161.JPG","Date":"2022-04-14 16:53:01","Longitude":-123.3424,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8162.JPG","Date":"2022-04-14 16:53:06","Longitude":-123.3424,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8163.JPG","Date":"2022-04-14 16:53:19","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8164.JPG","Date":"2022-04-14 16:53:23","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8165.JPG","Date":"2022-04-14 16:53:28","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8167.JPG","Date":"2022-04-14 16:53:59","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0062,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8168.JPG","Date":"2022-04-14 16:54:04","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8169.JPG","Date":"2022-04-14 16:54:07","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8170.JPG","Date":"2022-04-14 16:55:51","Longitude":-123.342,"Latitude":48.4962,"Exposure":0.0062,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8171.JPG","Date":"2022-04-14 16:56:04","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8172.JPG","Date":"2022-04-14 16:56:10","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8174.JPG","Date":"2022-04-14 16:56:16","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8175.JPG","Date":"2022-04-14 16:56:32","Longitude":-123.3421,"Latitude":48.4963,"Exposure":0.01,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8176.JPG","Date":"2022-04-14 16:57:06","Longitude":-123.3425,"Latitude":48.4963,"Exposure":0.008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8177.JPG","Date":"2022-04-14 16:57:09","Longitude":-123.3425,"Latitude":48.4963,"Exposure":0.0125,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8180.JPG","Date":"2022-04-14 16:58:00","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8182.JPG","Date":"2022-04-14 16:58:07","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8183.JPG","Date":"2022-04-14 16:58:13","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8184.JPG","Date":"2022-04-14 17:01:16","Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8185.JPG","Date":"2022-04-14 17:01:40","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8188.JPG","Date":"2022-04-14 17:02:02","Longitude":-123.3424,"Latitude":48.4963,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8189.JPG","Date":"2022-04-14 17:02:14","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8191.JPG","Date":"2022-04-14 17:02:19","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8192.JPG","Date":"2022-04-14 17:02:38","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8196.JPG","Date":"2022-04-14 17:02:51","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8198.JPG","Date":"2022-04-14 17:03:05","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8199.JPG","Date":"2022-04-14 17:04:38","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8200.JPG","Date":"2022-04-14 17:05:06","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8201.JPG","Date":"2022-04-14 17:05:10","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8202.JPG","Date":"2022-04-14 17:05:12","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8203.JPG","Date":"2022-04-14 17:05:14","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8204.JPG","Date":"2022-04-14 17:05:16","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8205.JPG","Date":"2022-04-14 17:16:22","Longitude":-123.3428,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":250,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8206.JPG","Date":"2022-04-14 17:16:27","Longitude":-123.3428,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":180,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8207.JPG","Date":"2022-04-14 17:16:30","Longitude":-123.3427,"Latitude":48.4964,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8208.JPG","Date":"2022-04-14 17:16:35","Longitude":-123.3427,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":160,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8209.JPG","Date":"2022-04-14 17:26:20","Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8211.JPG","Date":"2022-04-14 17:26:30","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8212.JPG","Date":"2022-04-14 17:26:35","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8213.JPG","Date":"2022-04-14 17:26:36","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8215.JPG","Date":"2022-04-14 17:26:48","Longitude":-123.3383,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8216.JPG","Date":"2022-04-14 17:26:50","Longitude":-123.3383,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.4,"ISO":250,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8217.JPG","Date":"2022-04-14 17:26:56","Longitude":-123.3383,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":4.4,"ISO":320,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8218.JPG","Date":"2022-04-14 17:27:15","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":4.4,"ISO":250,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8219.JPG","Date":"2022-04-14 17:27:29","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8220.JPG","Date":"2022-04-14 17:27:37","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8221.JPG","Date":"2022-04-14 17:28:25","Longitude":-123.338,"Latitude":48.4909,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8222.JPG","Date":"2022-04-14 17:28:32","Longitude":-123.338,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":2.8,"ISO":180,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8223.JPG","Date":"2022-04-14 17:28:40","Longitude":-123.338,"Latitude":48.491,"Exposure":0.01,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8225.JPG","Date":"2022-04-14 17:28:49","Longitude":-123.338,"Latitude":48.491,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8227.JPG","Date":"2022-04-14 17:29:10","Longitude":-123.3381,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.2,"ISO":140,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8229.JPG","Date":"2022-04-14 17:29:29","Longitude":-123.3382,"Latitude":48.4911,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8230.JPG","Date":"2022-04-14 17:29:48","Longitude":-123.3383,"Latitude":48.4911,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8231.JPG","Date":"2022-04-14 17:29:52","Longitude":-123.3384,"Latitude":48.4912,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8232.JPG","Date":"2022-04-14 17:30:10","Longitude":-123.3384,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8234.JPG","Date":"2022-04-14 17:30:38","Longitude":-123.3385,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":250,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8236.JPG","Date":"2022-04-14 17:31:00","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8237.JPG","Date":"2022-04-14 17:31:05","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8238.JPG","Date":"2022-04-14 17:31:27","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8239.JPG","Date":"2022-04-14 17:32:05","Longitude":-123.3389,"Latitude":48.4913,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8242.JPG","Date":"2022-04-14 17:32:27","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":320,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8244.JPG","Date":"2022-04-14 17:32:35","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8245.JPG","Date":"2022-04-14 17:32:42","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8246.JPG","Date":"2022-04-14 17:32:43","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8247.JPG","Date":"2022-04-14 17:32:48","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8248.JPG","Date":"2022-04-14 17:33:03","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8251.JPG","Date":"2022-04-14 17:33:10","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8255.JPG","Date":"2022-04-14 17:33:17","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8258.JPG","Date":"2022-04-14 17:33:29","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8259.JPG","Date":"2022-04-14 17:33:31","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8275.JPG","Date":"2022-04-14 17:34:19","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":200,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8276.JPG","Date":"2022-04-14 17:34:25","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8277.JPG","Date":"2022-04-14 17:34:26","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8280.JPG","Date":"2022-04-14 17:34:49","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8281.JPG","Date":"2022-04-14 17:34:55","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8283.JPG","Date":"2022-04-14 17:35:15","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":200,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8285.JPG","Date":"2022-04-14 17:36:10","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8287.JPG","Date":"2022-04-14 17:36:29","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8288.JPG","Date":"2022-04-14 17:36:36","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8289.JPG","Date":"2022-04-14 17:36:45","Longitude":-123.3393,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8290.JPG","Date":"2022-04-14 17:36:51","Longitude":-123.3393,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8292.JPG","Date":"2022-04-14 17:37:00","Longitude":-123.3392,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8293.JPG","Date":"2022-04-14 17:37:30","Longitude":-123.3395,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8294.JPG","Date":"2022-04-14 17:37:31","Longitude":-123.3395,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8295.JPG","Date":"2022-04-14 17:38:40","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8296.JPG","Date":"2022-04-14 17:38:45","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8298.JPG","Date":"2022-04-14 17:39:09","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8299.JPG","Date":"2022-04-14 17:39:11","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8304.JPG","Date":"2022-04-14 17:39:47","Longitude":-123.3399,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":320,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8306.JPG","Date":"2022-04-14 17:39:56","Longitude":-123.3399,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8308.JPG","Date":"2022-04-14 17:40:31","Longitude":-123.3401,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8309.JPG","Date":"2022-04-14 17:40:48","Longitude":-123.3401,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8310.JPG","Date":"2022-04-14 17:41:33","Longitude":-123.34,"Latitude":48.491,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8312.JPG","Date":"2022-04-14 17:43:49","Longitude":-123.3399,"Latitude":48.491,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8314.JPG","Date":"2022-04-14 17:44:09","Longitude":-123.3404,"Latitude":48.4912,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8315.JPG","Date":"2022-04-14 17:44:26","Longitude":-123.3405,"Latitude":48.4912,"Exposure":0.1,"F-Stop":4.2,"ISO":450,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8316.JPG","Date":"2022-04-14 17:44:39","Longitude":-123.3404,"Latitude":48.4911,"Exposure":0.04,"F-Stop":2.8,"ISO":400,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8317.JPG","Date":"2022-04-14 17:44:41","Longitude":-123.3404,"Latitude":48.4911,"Exposure":0.04,"F-Stop":2.8,"ISO":400,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8320.JPG","Date":"2022-04-14 17:50:37","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8324.JPG","Date":"2022-04-14 17:51:16","Longitude":-123.3397,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8328.JPG","Date":"2022-04-14 17:51:26","Longitude":-123.3397,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8330.JPG","Date":"2022-04-14 17:53:36","Longitude":-123.3391,"Latitude":48.4915,"Exposure":0.0667,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8333.JPG","Date":"2022-04-14 17:57:30","Longitude":-123.3388,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.8,"ISO":900,"Focal":18.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8334.JPG","Date":"2022-04-14 17:57:58","Longitude":-123.339,"Latitude":48.4915,"Exposure":0.0333,"F-Stop":2.8,"ISO":200,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"}]class(exif_json)## [1] "json"4.1 save all data as json file
write(exif_json, "./data/exif_json.json")5 remove rows without name, using dplyr, before creating json file
# https://stackoverflow.com/questions/9126840/delete-rows-with-blank-values-in-one-particular-column
class(exif_sort)## [1] "data.frame"View(exif_sort)
# https://stackoverflow.com/questions/9126840/delete-rows-with-blank-values-in-one-particular-column
exif_sort_name_nona <- exif_sort[!(is.na(exif_sort$Name) | exif_sort$Name==""), ]
class(exif_sort_name_nona)## [1] "data.frame"View(exif_sort_name_nona)5.1 Sort no NA data by Name before creating json file
exif_sort_name_nona_sort <- exif_sort_name_nona[order(exif_sort_name_nona$Name, decreasing = FALSE), ]
exif_sort_name_nona_sort## Image Date Longitude Latitude Exposure F-Stop
## 4 DSCN7965.JPG 2022-04-14 14:50:57 -123.3453 48.49260 0.00250000 4.9
## 5 DSCN7966.JPG 2022-04-14 14:51:05 -123.3452 48.49255 0.00250000 4.9
## 6 DSCN7967.JPG 2022-04-14 14:51:11 -123.3452 48.49252 0.00250000 4.9
## 7 DSCN7968.JPG 2022-04-14 14:51:13 -123.3452 48.49252 0.00250000 4.9
## 8 DSCN7969.JPG 2022-04-14 14:51:15 -123.3452 48.49256 0.00250000 4.9
## 9 DSCN7970 copy.JPG 2022-04-14 14:51:16 -123.3452 48.49258 0.00250000 4.9
## 10 DSCN7970.JPG 2022-04-14 14:51:16 -123.3452 48.49258 0.00250000 4.9
## 26 DSCN7992.JPG 2022-04-14 14:57:21 -123.3456 48.49316 0.02500000 4.2
## 27 DSCN7999.JPG 2022-04-14 14:58:25 -123.3457 48.49313 0.01666667 2.8
## 30 DSCN8004.JPG 2022-04-14 14:58:53 -123.3456 48.49305 0.02000000 2.8
## 31 DSCN8005.JPG 2022-04-14 14:59:07 -123.3456 48.49307 0.01666667 2.8
## 32 DSCN8006.JPG 2022-04-14 14:59:16 -123.3456 48.49316 0.01666667 2.8
## 33 DSCN8007.JPG 2022-04-14 14:59:17 -123.3456 48.49314 0.01666667 2.8
## 11 DSCN7971.JPG 2022-04-14 14:52:28 -123.3454 48.49294 0.02000000 4.2
## 14 DSCN7977.JPG 2022-04-14 14:53:54 -123.3454 48.49312 0.01250000 4.2
## 17 DSCN7980.JPG 2022-04-14 14:54:42 -123.3455 48.49312 0.00800000 4.2
## 15 DSCN7978.JPG 2022-04-14 14:54:26 -123.3455 48.49312 0.00200000 4.2
## 16 DSCN7979.JPG 2022-04-14 14:54:29 -123.3454 48.49313 0.01000000 4.2
## 13 DSCN7975.JPG 2022-04-14 14:52:41 -123.3453 48.49288 0.00800000 4.2
## 18 DSCN7982.JPG 2022-04-14 14:54:58 -123.3456 48.49306 0.01666667 4.2
## 19 DSCN7983.JPG 2022-04-14 14:55:04 -123.3456 48.49303 0.03333333 4.2
## 20 DSCN7984.JPG 2022-04-14 14:55:09 -123.3457 48.49317 0.03333333 4.2
## 21 DSCN7985.JPG 2022-04-14 14:55:12 -123.3457 48.49321 0.02500000 4.2
## 39 DSCN8014.JPG 2022-04-14 15:02:51 -123.3458 48.49294 0.00100000 2.8
## 40 DSCN8017.JPG 2022-04-14 15:03:24 -123.3458 48.49291 0.00080000 2.8
## ISO Focal Desc Name Location
## 4 125 21.5 BF Bee Fly Mt. Douglas
## 5 125 21.5 BF Bee Fly Mt. Douglas
## 6 125 21.5 BF Bee Fly Mt. Douglas
## 7 125 21.5 BF Bee Fly Mt. Douglas
## 8 125 21.5 BF Bee Fly Mt. Douglas
## 9 125 21.5 BF Bee Fly Mt. Douglas
## 10 125 21.5 BF Bee Fly Mt. Douglas
## 26 125 7.2 CL Chocolate Lily Mt. Douglas
## 27 125 5.1 CL Chocolate Lily Mt. Douglas
## 30 125 4.3 CL Chocolate Lily Mt. Douglas
## 31 125 4.3 CL Chocolate Lily Mt. Douglas
## 32 125 4.3 CL Chocolate Lily Mt. Douglas
## 33 125 4.3 CL Chocolate Lily Mt. Douglas
## 11 125 7.2 FL Fawn Lily Mt. Douglas
## 14 125 7.2 FL Fawn Lily Mt. Douglas
## 17 125 7.2 FL Fawn Lily Mt. Douglas
## 15 125 7.2 LF Licorice Fern Mt. Douglas
## 16 125 7.2 LF Licorice Fern Mt. Douglas
## 13 125 7.2 ML Miners Lettuce Mt. Douglas
## 18 125 7.2 MF Monkey Flower Mt. Douglas
## 19 125 7.2 MF Monkey Flower Mt. Douglas
## 20 125 7.2 MF Monkey Flower Mt. Douglas
## 21 125 7.2 MF Monkey Flower Mt. Douglas
## 39 125 4.3 Monkey Flower Mt. Douglas
## 40 125 4.3 Monkey Flower Mt. Douglasclass(exif_sort_name_nona_sort)## [1] "data.frame"6 {jsonlite} create json object from no NA’s
exif_json_nona_sortname <- toJSON(exif_sort_name_nona_sort)
exif_json_nona_sortname## [{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"}]class(exif_json_nona_sortname)## [1] "json"6.1 save na NA data as json file
copy the text from this file to html file
write(exif_json_nona_sortname, "./data/exif_json_nona_sort.json")7 HTML file for Leaflet map using json data
<html lang="en">
<head>
<title>Leaflet Map - List Reference</title>
<link rel="icon" href="https://people.geog.uvic.ca/wanthony/website/favicon.png">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta charset="UTF-8">
<meta name="description" content="Leaflet Map - List Reference">
<meta name="keywords" content="Leaflet, Map, Test">
<meta name="author" content="Wendy Anthony">
<!-- code reference
https://stackoverflow.com/questions/46302216/leaflet-trigger-event-on-clustered-marker-by-external-element
https://jsfiddle.net/2gze75L6/6/
-->
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet.css">
<link rel="stylesheet" type="text/css" href="https://leaflet.github.io/Leaflet.markercluster/dist/MarkerCluster.Default.css">
<link rel="stylesheet" type="text/css" href="https://leaflet.github.io/Leaflet.markercluster/dist/MarkerCluster.css">
</head>
<style type="text/css">
#map {
width: 800px;
height: 1000px;
border: 1px solid #ccc;
}
#progress {
display: none;
position: absolute;
z-index: 1000;
left: 400px;
top: 300px;
width: 200px;
height: 20px;
margin-top: -20px;
margin-left: -100px;
background-color: #fff;
background-color: rgba(255, 255, 255, 0.7);
border-radius: 4px;
padding: 2px;
}
#progress-bar {
width: 0;
height: 100%;
background-color: #76A6FC;
border-radius: 4px;
}
.prop-div-icon {
border-radius: 5px;
background-color: #3a87ad;
min-width: 50px;
min-height: 20px;
font-weight: bold;
color: white;
text-align: center;
}
.prop-div-icon-shadow {
top: -3px;
left: -3px;
border-radius: 5px;
background-color: #5bc0de;
border-color: #3a87ad;
border: 1px solid;
min-width: 50px;
min-height: 20px;
font-weight: bold;
color: white;
text-align: center;
box-shadow: 3px 3px 3px 0px rgba(125, 125, 125, 0.8);
}
.prop-li-item {
cursor: pointer;
}
</style>
<body>
<div class="container">
<div class="row">
<div class="col-md-4">
<div><h4>Native Plants @ Mt Douglas</h4>
<strong>Total Images = <em><span style="font-size: larger;" id="totalData"></span></em></strong>
</div>
<div></div>
<div id="list"></div>
</div>
<div class="col-md-8">
<div id="map" style="max-width: 640px; max-height: 1280px;"></div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet-src.js"></script>
<script src="https://leaflet.github.io/Leaflet.markercluster/dist/leaflet.markercluster-src.js"></script>
<script type="text/javascript">
var tiles = L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
maxZoom: 15
});
var latlng = L.latLng(48.4926, -123.3453);
var map = L.map('map', {
center: latlng,
layers: [tiles]
});
var markers = L.markerClusterGroup();
var markersRef = {};
/*
>> **** if json data is sorted and doesn't contain any NA values in Name field
>> just copy
>>> can't use Name that has oppostrophe e.g. Miner's Lettuce s/b Miners Lettuce
json data needs to have a hard return between values
> in json file search for },{
> make a hard return, and copy
> add this copied hard return after the , comma
> when copied into this code, the json values must turn yellow (in Sublime)
>>
>>
> each datapoint MUST have a Name
>>
>>
> Description Field is the label shown for marker
>>
*/
var theDatax = [{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"}]
mapReload();
function mapReload() {
// **Clear List**
var ul = document.getElementById("list");
ul.innerHTML = '';
updateMapMarkerResult(theDatax);
map.fitBounds(markers.getBounds());
}
function updateMapMarkerResult(data) {
markers.clearLayers();
for (var i = 0; i < data.length; i++) {
var a = data[i];
var myIcon = L.divIcon({
className: 'prop-div-icon',
html: a.Desc
});
var marker = L.marker(new L.LatLng(a.Latitude, a.Longitude), {
icon: myIcon
}, {
title: a.Name
});
marker.bindPopup('<div><div class="row"><h5>Name : ' + a.Name + '</h5></div><div class="row"><h5>Date : ' + a.Date + '</h5></div><div class="row">Lat : ' + a.Latitude + '</div><div class="row">Lng : ' + a.Longitude + '</div>' + '<div class="row"><h5>Image: ' + a.Image + '</h5>' + '<img src = "/Volumes/MyPassportForMac/Pictures/!!Nikon-Camera/Nikon-Coolpix-GPS/2022-04-14-MtDouglasPark/' + a.Image + '" style="width:314px; height:239px;"></div>' + '</div>');
/*
'<div class="row"><img src = "' + Desc + '" style="width:314px; height:239px;"></div>' +
+
*/
marker.on('mouseover', function(e) {
if (this._icon != null) {
this._icon.classList.remove("prop-div-icon");
this._icon.classList.add("prop-div-icon-shadow");
}
});
marker.on('mouseout', function(e) {
if (this._icon != null) {
this._icon.classList.remove("prop-div-icon-shadow");
this._icon.classList.add("prop-div-icon");
}
});
markersRef[a.Image] = marker;
markers.addLayer(marker);
updateMapListResult(a, i + 1);
}
map.addLayer(markers);
}
function updateMapListResult(data, totalData) {
var ul = document.getElementById("list");
var li = document.createElement("li");
li.setAttribute('marker', data.Image);
li.setAttribute('class', 'prop-li-item');
li.appendChild(document.createTextNode(data.Name));
// ** Event : Mouse Over **
li.addEventListener("mouseover", function(e) {
jQuery(this).addClass("btn-info");
//markersRef[this.getAttribute('marker')].fire('mouseover'); // --> Trigger Marker Event "mouseover"
var marker = markersRef[this.getAttribute('marker')];
_fireEventOnMarkerOrVisibleParentCluster(marker, 'mouseover');
// TODO : Trigger ClusteredMarker Event "mouseover"
});
// ** Event : Mouse Over **
li.addEventListener("mouseout", function(e) {
jQuery(this).removeClass("btn-info");
//markersRef[this.getAttribute('marker')].fire('mouseout'); // --> Trigger Marker Event "mouseout"
var marker = markersRef[this.getAttribute('marker')];
_fireEventOnMarkerOrVisibleParentCluster(marker, 'mouseout');
// TODO : Trigger ClusteredMarker Event "mouseout"
});
// ** Event : Click **
li.addEventListener("click", function(e) {
markersRef[this.getAttribute('marker')].fire('click');
});
ul.appendChild(li);
var spanTotalData = document.getElementById("totalData");
spanTotalData.innerHTML = totalData;
}
function _fireEventOnMarkerOrVisibleParentCluster(marker, eventName) {
if (eventName === 'mouseover') {
var visibleLayer = markers.getVisibleParent(marker);
if (visibleLayer instanceof L.MarkerCluster) {
// We want to show a marker that is currently hidden in a cluster.
// Make sure it will get highlighted once revealed.
markers.once('spiderfied', function() {
marker.fire(eventName);
});
// Now spiderfy its containing cluster to reveal it.
// This will automatically unspiderfy other clusters.
visibleLayer.spiderfy();
} else {
// The marker is already visible, unspiderfy other clusters if
// they do not contain the marker.
_unspiderfyPreviousClusterIfNotParentOf(marker);
marker.fire(eventName);
}
} else {
// For mouseout, marker is necessarily unclustered already.
marker.fire(eventName);
}
}
function _unspiderfyPreviousClusterIfNotParentOf(marker) {
// Check if there is a currently spiderfied cluster.
// If so and it does not contain the marker, unspiderfy it.
var spiderfiedCluster = markers._spiderfied;
if (
spiderfiedCluster
&& !_clusterContainsMarker(spiderfiedCluster, marker)
) {
spiderfiedCluster.unspiderfy();
}
}
function _clusterContainsMarker(cluster, marker) {
var currentLayer = marker;
while (currentLayer && currentLayer !== cluster) {
currentLayer = currentLayer.__parent;
}
// Say if we found a cluster or nothing.
return !!currentLayer;
}
</script>
</body>
</html>7.1 html leaflet map screenshots
Leaflet Map (screenshot)
Leaflet Map - open (screenshot